Question 1
Column
Las 10 provincias con más denuncias en 2024
|
Year
|
Department
|
Province
|
Cases
|
|
2024
|
LIMA METROPOLITANA
|
LIMA
|
7888
|
|
2024
|
LA LIBERTAD
|
TRUJILLO
|
3378
|
|
2024
|
PIURA
|
PIURA
|
925
|
|
2024
|
PIURA
|
SULLANA
|
830
|
|
2024
|
LAMBAYEQUE
|
CHICLAYO
|
664
|
|
2024
|
PROV. CONST. DEL CALLAO
|
CALLAO
|
619
|
|
2024
|
ANCASH
|
SANTA
|
501
|
|
2024
|
LA LIBERTAD
|
PACASMAYO
|
485
|
|
2024
|
LA LIBERTAD
|
ASCOPE
|
465
|
|
2024
|
AREQUIPA
|
AREQUIPA
|
334
|
Column
Cambios en las top 10 provincias

Question 2
Column
Casos y variación porcentual
|
Department
|
Province
|
Cases_2018
|
Cases_2024
|
variacion_pct
|
|
REGION LIMA
|
HUARAL
|
3
|
314
|
10366.67
|
|
CAJAMARCA
|
SAN MARCOS
|
1
|
47
|
4600.00
|
|
REGION LIMA
|
HUAROCHIRI
|
1
|
47
|
4600.00
|
|
CUSCO
|
LA CONVENCION
|
1
|
43
|
4200.00
|
|
MOQUEGUA
|
ILO
|
1
|
26
|
2500.00
|
|
TACNA
|
TACNA
|
5
|
121
|
2320.00
|
|
LA LIBERTAD
|
PATAZ
|
1
|
24
|
2300.00
|
|
APURIMAC
|
ANDAHUAYLAS
|
1
|
23
|
2200.00
|
|
CAJAMARCA
|
CAJABAMBA
|
8
|
166
|
1975.00
|
|
CAJAMARCA
|
HUALGAYOC
|
1
|
20
|
1900.00
|
Casos y Z Score
|
Department
|
Province
|
Cases_2018
|
Cases_2024
|
Z_score
|
|
LIMA METROPOLITANA
|
LIMA
|
620
|
7888
|
127.82923
|
|
LA LIBERTAD
|
TRUJILLO
|
608
|
3378
|
66.92582
|
|
PIURA
|
SULLANA
|
67
|
830
|
41.24874
|
|
PROV. CONST. DEL CALLAO
|
CALLAO
|
75
|
619
|
32.43891
|
|
LA LIBERTAD
|
PACASMAYO
|
35
|
485
|
32.21327
|
|
REGION LIMA
|
HUARAL
|
3
|
314
|
31.97599
|
|
PIURA
|
PIURA
|
221
|
925
|
31.09549
|
|
REGION LIMA
|
BARRANCA
|
29
|
332
|
25.67140
|
|
LAMBAYEQUE
|
CHICLAYO
|
189
|
664
|
24.04094
|
|
AREQUIPA
|
AREQUIPA
|
41
|
334
|
23.74509
|
Column
Grafico de barras con variación porcentual

Gráfico de barras con el Z-score

Question 3
Column
Casos y variación porcentual
|
Department
|
Province
|
Cases_2021
|
Cases_2024
|
variacion_pct
|
|
APURIMAC
|
ANDAHUAYLAS
|
1
|
23
|
2200.000
|
|
CAJAMARCA
|
CAJABAMBA
|
8
|
166
|
1975.000
|
|
CAJAMARCA
|
HUALGAYOC
|
1
|
20
|
1900.000
|
|
LA LIBERTAD
|
GRAN CHIMU
|
1
|
17
|
1600.000
|
|
LORETO
|
ALTO AMAZONAS
|
1
|
17
|
1600.000
|
|
REGION LIMA
|
HUARAL
|
21
|
314
|
1395.238
|
|
ANCASH
|
HUARI
|
1
|
14
|
1300.000
|
|
ICA
|
PALPA
|
1
|
13
|
1200.000
|
|
SAN MARTIN
|
MARISCAL CACERES
|
1
|
11
|
1000.000
|
|
TUMBES
|
CONTRALMIRANTE VILLAR
|
1
|
11
|
1000.000
|
Casos y Z Score
|
Department
|
Province
|
Cases_2021
|
Cases_2024
|
Z_score
|
|
LIMA METROPOLITANA
|
LIMA
|
1379
|
7888
|
103.35905
|
|
LA LIBERTAD
|
TRUJILLO
|
651
|
3378
|
65.21173
|
|
PIURA
|
SULLANA
|
114
|
830
|
36.26528
|
|
REGION LIMA
|
HUARAL
|
21
|
314
|
26.27494
|
|
PIURA
|
PIURA
|
322
|
925
|
24.93891
|
|
LA LIBERTAD
|
PACASMAYO
|
93
|
485
|
24.75813
|
|
LAMBAYEQUE
|
CHICLAYO
|
188
|
664
|
24.11378
|
|
PROV. CONST. DEL CALLAO
|
CALLAO
|
176
|
619
|
23.22642
|
|
CAJAMARCA
|
CAJABAMBA
|
8
|
166
|
20.11134
|
|
ANCASH
|
SANTA
|
154
|
501
|
19.94671
|
Column
Grafico de barras con variación porcentual

Gráfico de barras con el Z-score

Question 4
Column
Casos y variación porcentual
|
Department
|
Province
|
Cases_2021
|
Cases_2022
|
variacion_pct
|
|
APURIMAC
|
ANDAHUAYLAS
|
1
|
14
|
1300.0000
|
|
LA LIBERTAD
|
GRAN CHIMU
|
1
|
13
|
1200.0000
|
|
AREQUIPA
|
CARAVELI
|
2
|
21
|
950.0000
|
|
TUMBES
|
CONTRALMIRANTE VILLAR
|
1
|
10
|
900.0000
|
|
CAJAMARCA
|
HUALGAYOC
|
1
|
8
|
700.0000
|
|
AREQUIPA
|
CAMANA
|
6
|
45
|
650.0000
|
|
JUNIN
|
CHANCHAMAYO
|
6
|
37
|
516.6667
|
|
REGION LIMA
|
OYON
|
1
|
6
|
500.0000
|
|
SAN MARTIN
|
TOCACHE
|
3
|
18
|
500.0000
|
|
REGION LIMA
|
CAÑETE
|
41
|
242
|
490.2439
|
Casos y Z Score
|
Department
|
Province
|
Cases_2021
|
Cases_2022
|
Z_score
|
|
LIMA METROPOLITANA
|
LIMA
|
1379
|
7658
|
100.75022
|
|
PROV. CONST. DEL CALLAO
|
CALLAO
|
176
|
746
|
28.09300
|
|
LA LIBERTAD
|
TRUJILLO
|
651
|
1439
|
24.83890
|
|
PIURA
|
SULLANA
|
114
|
434
|
20.31118
|
|
REGION LIMA
|
CAÑETE
|
41
|
242
|
18.30645
|
|
ICA
|
ICA
|
52
|
213
|
14.76683
|
|
REGION LIMA
|
HUAURA
|
67
|
242
|
14.74199
|
|
AREQUIPA
|
AREQUIPA
|
84
|
266
|
14.28871
|
|
PIURA
|
TALARA
|
32
|
147
|
12.93500
|
|
REGION LIMA
|
HUARAL
|
21
|
121
|
12.83485
|
Column
Grafico de barras con variación porcentual

Gráfico de barras con el Z-score

Column
Autocorrelación espacial - LISA (aporte desde mi tesis)

Question 6
Column
Número de denuncias en los distritos de Trujillo
